/*
use master
*/
use ManLab
go


insert into Test values('BloodTest',100000)
insert into Test values('BoneScan',200000)
insert into Test values('Injection',50000)
go
insert into StockDetail values('vitro',50,default)
insert into StockDetail values('syringe',100,default)
insert into StockDetail values('film',200,default)
go
insert into ItemRequire values(1,1,2)
insert into ItemRequire values(2,2,3)
insert into ItemRequire values(3,1,2)
go
insert into PatientDetail values('viet','luong','Hanoi','123434',default,'1982/02/01')

go	
insert into StaffDetail values('Quang','Doan','2010/01/01','Hanoi1','12345678',1,'1990/01/01','Graduated','Mechanic','password','quangd1')
go
insert into DoctorDetail values('Quan','Nguyen','Hanoi','12345678',1,'Dentist','password','quann1')

go
insert into Report values(1,1,1,1,'2012/01/01','This is a good test',-1)

go
insert into Admin values('123456')
go
/*
select * from Report
delete from Report
*/